/*
 Navicat Premium Data Transfer

 Source Server         : inter-star-uat
 Source Server Type    : MySQL
 Source Server Version : 80400
 Source Host           : localhost:3307
 Source Schema         : inter-star

 Target Server Type    : MySQL
 Target Server Version : 80400
 File Encoding         : 65001

 Date: 09/07/2024 11:32:08
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for asset
-- ----------------------------
DROP TABLE IF EXISTS `asset`;
CREATE TABLE `asset` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `sar` decimal(20,6) DEFAULT NULL,
  `iar` decimal(20,6) DEFAULT NULL,
  `ciar` decimal(20,6) DEFAULT NULL,
  `tiar` decimal(20,6) DEFAULT NULL,
  `mint` decimal(20,6) DEFAULT NULL,
  `mgt` decimal(20,6) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  CONSTRAINT `fk_user_asset` FOREIGN KEY (`id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of asset
-- ----------------------------
BEGIN;
INSERT INTO `asset` VALUES (25, 10000.000000, 0.000000, 960.000000, 0.000000, 0.000000, 0.000000);
INSERT INTO `asset` VALUES (26, 3990.000000, 0.000000, 90.000000, 910.000000, 0.000000, 0.000000);
INSERT INTO `asset` VALUES (27, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000);
INSERT INTO `asset` VALUES (28, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000);
COMMIT;

-- ----------------------------
-- Table structure for asset_record
-- ----------------------------
DROP TABLE IF EXISTS `asset_record`;
CREATE TABLE `asset_record` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `from_user_id` bigint DEFAULT NULL,
  `from_asset_type` longtext,
  `from_asset_amount` decimal(20,6) DEFAULT NULL,
  `from_asset_price` decimal(20,6) DEFAULT NULL,
  `to_user_id` bigint DEFAULT NULL,
  `to_asset_type` longtext,
  `to_asset_amount` decimal(20,6) DEFAULT NULL,
  `to_asset_price` decimal(20,6) DEFAULT NULL,
  `to_binance_address` longtext,
  `to_tron_address` longtext,
  `tx_hash` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `energy_block_id` bigint DEFAULT NULL,
  `fee` decimal(20,6) DEFAULT NULL,
  `trade_type` longtext,
  `status` longtext,
  `desc` longtext,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint DEFAULT NULL,
  `created_at` datetime(3) DEFAULT NULL,
  `updated_at` datetime(3) DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of asset_record
-- ----------------------------
BEGIN;
INSERT INTO `asset_record` VALUES (50, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0x2271a2facc064576a4d348ee3aa8ac5559eac9473f89a0c6892f64525d4f28bf', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 20:56:39.686', '2024-07-08 20:56:39.686', NULL);
INSERT INTO `asset_record` VALUES (51, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0xaa498ca0192ab073bcf7be0a048783175199e43857074758b51fcf9cb91dc2a7', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 20:56:46.916', '2024-07-08 20:56:46.916', NULL);
INSERT INTO `asset_record` VALUES (52, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0xb2267020cbb23181d7adb8fac8646e0e51d0eea2144fe08349c8f8b1a7ef6a48', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 20:56:49.830', '2024-07-08 20:56:49.830', NULL);
INSERT INTO `asset_record` VALUES (53, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0x8ad9f51b578c868e936f4cf0004dc589f92c5a66b3283d36dd8c8b89d3ec7484', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 20:56:53.459', '2024-07-08 20:56:53.459', NULL);
INSERT INTO `asset_record` VALUES (54, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0x96f338415dbcece78730af8086cc6270342d6816e78590b4422d2e5fb5ad390c', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 20:56:58.006', '2024-07-08 20:56:58.006', NULL);
INSERT INTO `asset_record` VALUES (55, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0x675eb9853effa1bccb7d3b868ead73120f157d39908cec70819f7e25d474031f', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 20:57:02.096', '2024-07-08 20:57:02.096', NULL);
INSERT INTO `asset_record` VALUES (56, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0xb47d0107e72469489875260c81749e87cc058b8b56a52d11cfba022503aa997b', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 20:57:05.734', '2024-07-08 20:57:05.734', NULL);
INSERT INTO `asset_record` VALUES (57, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0x4256b11e7bb67e5e1c19a544ef013110ae7068ca425b4fc7c1bfabad5fe56d44', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 20:57:21.106', '2024-07-08 20:57:21.106', NULL);
INSERT INTO `asset_record` VALUES (58, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0x319ac000542db55f54eed6e723b8b0cc9aa66ac785ed1e7da6b37f7d42eb35cf', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 20:58:57.971', '2024-07-08 20:58:57.971', NULL);
INSERT INTO `asset_record` VALUES (59, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0xfca105be719ad344c06cfe84b44973ddd31d271aa475b0b8656cbeac1c6972ad', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 21:54:31.004', '2024-07-08 21:54:31.004', NULL);
INSERT INTO `asset_record` VALUES (60, 0, 'binance', 1000.000000, 1000000000.000000, 25, 'sar', 1000.000000, 1.000000, '', '', '0x368b7cca0a722175d800b27b64641bf8ad8e4b07edd14c271027e67e7d564692', 0, NULL, 'recharge', 'approved', '', 0, 0, '2024-07-08 21:56:04.214', '2024-07-08 21:56:04.214', NULL);
INSERT INTO `asset_record` VALUES (61, 25, 'sar', 1000.000000, 1.000000, 25, 'tiar', 1000.000000, 1.000000, '', '', '', 0, NULL, 'exchange', 'approved', '', 25, 25, '2024-07-09 00:12:16.782', '2024-07-09 00:12:16.782', NULL);
INSERT INTO `asset_record` VALUES (62, 25, 'tiar', 1000.000000, 1.000000, 25, 'ciar', 1000.000000, 1.000000, '', '', '', 0, NULL, 'exchange', 'approved', '', 25, 25, '2024-07-09 00:12:40.549', '2024-07-09 00:12:40.549', NULL);
INSERT INTO `asset_record` VALUES (66, 25, 'ciar', 10.000000, 1.000000, 25, 'EnergyBlock', 1.000000, 10.000000, '', '', '', 0, NULL, 'buy', 'approved', '', 25, 25, '2024-07-09 00:19:47.677', '2024-07-09 00:19:47.677', NULL);
INSERT INTO `asset_record` VALUES (67, 25, 'ciar', 10.000000, 1.000000, 25, 'EnergyBlock', 1.000000, 10.000000, '', '', '', 0, NULL, 'buy', 'approved', '', 25, 25, '2024-07-09 00:26:25.775', '2024-07-09 00:26:25.775', NULL);
INSERT INTO `asset_record` VALUES (68, 25, 'ciar', 10.000000, 1.000000, 25, 'EnergyBlock', 1.000000, 10.000000, '', '', '', 0, NULL, 'buy', 'approved', '', 25, 25, '2024-07-09 00:28:40.816', '2024-07-09 00:28:40.816', NULL);
INSERT INTO `asset_record` VALUES (69, 25, 'ciar', 10.000000, 1.000000, 25, 'EnergyBlock', 1.000000, 10.000000, '', '', '', 0, NULL, 'buy', 'approved', '', 25, 25, '2024-07-09 00:29:42.843', '2024-07-09 00:29:42.843', NULL);
INSERT INTO `asset_record` VALUES (74, 25, 'EnergyBlock', NULL, NULL, 25, 'ciar', 0.066667, 1.000000, '', '', '', 6, NULL, 'earnings', 'approved', '', 25, 25, '2024-07-09 00:36:37.148', '2024-07-09 00:36:37.148', NULL);
INSERT INTO `asset_record` VALUES (75, 25, 'EnergyBlock', NULL, NULL, 25, 'ciar', 0.066667, 1.000000, '', '', '', 7, NULL, 'earnings', 'approved', '', 25, 25, '2024-07-09 00:36:38.529', '2024-07-09 00:36:38.529', NULL);
INSERT INTO `asset_record` VALUES (76, 25, 'EnergyBlock', NULL, NULL, 25, 'ciar', 0.066667, 1.000000, '', '', '', 8, NULL, 'earnings', 'approved', '', 25, 25, '2024-07-09 00:36:39.477', '2024-07-09 00:36:39.477', NULL);
INSERT INTO `asset_record` VALUES (77, 25, 'EnergyBlock', NULL, NULL, 25, 'ciar', 0.066667, 1.000000, '', '', '', 9, NULL, 'earnings', 'approved', '', 25, 25, '2024-07-09 00:36:40.430', '2024-07-09 00:36:40.430', NULL);
INSERT INTO `asset_record` VALUES (78, 26, 'sar', 10.000000, 1.000000, 26, 'tiar', 10.000000, 1.000000, '', '', '', 0, NULL, 'exchange', 'approved', '', 26, 26, '2024-07-09 02:59:18.528', '2024-07-09 02:59:18.528', NULL);
INSERT INTO `asset_record` VALUES (79, 26, 'sar', 1000.000000, 1.000000, 26, 'tiar', 1000.000000, 1.000000, '', '', '', 0, NULL, 'exchange', 'approved', '', 26, 26, '2024-07-09 03:00:49.194', '2024-07-09 03:00:49.194', NULL);
INSERT INTO `asset_record` VALUES (80, 26, 'tiar', 500.000000, 1.000000, 26, 'sar', 500.000000, 1.000000, '', '', '', 0, NULL, 'exchange', 'approved', '', 26, 26, '2024-07-09 03:01:12.519', '2024-07-09 03:01:12.519', NULL);
INSERT INTO `asset_record` VALUES (81, 26, 'sar', 1000.000000, 1.000000, 26, 'tiar', 1000.000000, 1.000000, '', '', '', 0, NULL, 'exchange', 'approved', '', 26, 26, '2024-07-09 03:01:42.644', '2024-07-09 03:01:42.644', NULL);
INSERT INTO `asset_record` VALUES (82, 26, 'tiar', 500.000000, 1.000000, 26, 'sar', 500.000000, 1.000000, '', '', '', 0, NULL, 'exchange', 'approved', '', 26, 26, '2024-07-09 03:01:59.329', '2024-07-09 03:01:59.329', NULL);
INSERT INTO `asset_record` VALUES (83, 26, 'tiar', 100.000000, 1.000000, 26, 'ciar', 100.000000, 1.000000, '', '', '', 0, NULL, 'exchange', 'approved', '', 26, 26, '2024-07-09 03:02:50.014', '2024-07-09 03:02:50.014', NULL);
INSERT INTO `asset_record` VALUES (84, 26, 'ciar', 10.000000, 1.000000, 26, 'EnergyBlock', 1.000000, 10.000000, '', '', '', 0, NULL, 'buy', 'approved', '', 26, 26, '2024-07-09 03:13:15.957', '2024-07-09 03:13:15.957', NULL);
COMMIT;

-- ----------------------------
-- Table structure for binance_transfer
-- ----------------------------
DROP TABLE IF EXISTS `binance_transfer`;
CREATE TABLE `binance_transfer` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint DEFAULT NULL,
  `tx_hash` varchar(191) DEFAULT NULL,
  `from` longtext,
  `amount` decimal(20,6) DEFAULT NULL,
  `created_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tx_hash` (`tx_hash`)
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of binance_transfer
-- ----------------------------
BEGIN;
INSERT INTO `binance_transfer` VALUES (137, 25, '0x2271a2facc064576a4d348ee3aa8ac5559eac9473f89a0c6892f64525d4f28bf', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 20:56:39.216');
INSERT INTO `binance_transfer` VALUES (138, 25, '0xaa498ca0192ab073bcf7be0a048783175199e43857074758b51fcf9cb91dc2a7', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 20:56:45.588');
INSERT INTO `binance_transfer` VALUES (139, 25, '0xb2267020cbb23181d7adb8fac8646e0e51d0eea2144fe08349c8f8b1a7ef6a48', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 20:56:49.365');
INSERT INTO `binance_transfer` VALUES (140, 25, '0x8ad9f51b578c868e936f4cf0004dc589f92c5a66b3283d36dd8c8b89d3ec7484', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 20:56:52.995');
INSERT INTO `binance_transfer` VALUES (141, 25, '0x96f338415dbcece78730af8086cc6270342d6816e78590b4422d2e5fb5ad390c', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 20:56:57.543');
INSERT INTO `binance_transfer` VALUES (142, 25, '0x675eb9853effa1bccb7d3b868ead73120f157d39908cec70819f7e25d474031f', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 20:57:01.625');
INSERT INTO `binance_transfer` VALUES (143, 25, '0xb47d0107e72469489875260c81749e87cc058b8b56a52d11cfba022503aa997b', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 20:57:05.269');
INSERT INTO `binance_transfer` VALUES (144, 25, '0x4256b11e7bb67e5e1c19a544ef013110ae7068ca425b4fc7c1bfabad5fe56d44', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 20:57:20.338');
INSERT INTO `binance_transfer` VALUES (145, 25, '0x319ac000542db55f54eed6e723b8b0cc9aa66ac785ed1e7da6b37f7d42eb35cf', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 20:58:57.506');
INSERT INTO `binance_transfer` VALUES (146, 25, '0xfca105be719ad344c06cfe84b44973ddd31d271aa475b0b8656cbeac1c6972ad', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 21:54:30.995');
INSERT INTO `binance_transfer` VALUES (147, 25, '0x368b7cca0a722175d800b27b64641bf8ad8e4b07edd14c271027e67e7d564692', '0xefc560794ffdeb380af26716cd1da521aea46cf3', 1000.000000, '2024-07-08 21:56:04.201');
COMMIT;

-- ----------------------------
-- Table structure for energy_block
-- ----------------------------
DROP TABLE IF EXISTS `energy_block`;
CREATE TABLE `energy_block` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint DEFAULT NULL,
  `level` longtext,
  `period_number` bigint DEFAULT NULL,
  `current_period_day_count` bigint DEFAULT NULL,
  `day_number` bigint DEFAULT NULL,
  `produced_amount` decimal(20,6) DEFAULT NULL,
  `star_point` int DEFAULT NULL,
  `team_path` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `expired` tinyint(1) DEFAULT NULL,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint DEFAULT NULL,
  `created_at` datetime(3) DEFAULT NULL,
  `updated_at` datetime(3) DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of energy_block
-- ----------------------------
BEGIN;
INSERT INTO `energy_block` VALUES (6, 25, '2', 1, 30, 1, 0.066667, 1, '1,25', 0, 25, 25, '2024-07-09 00:19:43.195', '2024-07-09 00:36:38.056', NULL);
INSERT INTO `energy_block` VALUES (7, 25, '2', 1, 30, 1, 0.066667, 1, '1,25', 0, 25, 25, '2024-07-09 00:26:25.303', '2024-07-09 00:36:39.002', NULL);
INSERT INTO `energy_block` VALUES (8, 25, '2', 1, 30, 1, 0.066667, 1, '1,25', 0, 25, 25, '2024-07-09 00:28:40.341', '2024-07-09 00:36:39.958', NULL);
INSERT INTO `energy_block` VALUES (9, 25, '2', 1, 30, 1, 0.066667, 1, '1,25', 0, 25, 25, '2024-07-09 00:29:41.400', '2024-07-09 00:36:40.904', NULL);
INSERT INTO `energy_block` VALUES (10, 26, '1', 1, 30, 0, 0.000000, 0, '1,26', 0, 26, 26, '2024-07-09 03:13:15.957', '2024-07-09 03:13:15.957', NULL);
COMMIT;

-- ----------------------------
-- Table structure for setting
-- ----------------------------
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `system_name` longtext,
  `system_brief` longtext,
  `system_detail` longtext,
  `system_logo` longtext,
  `system_copyright` longtext,
  `app_version` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `app_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `tts_access_key_id` longtext,
  `tts_access_key_secret` longtext,
  `tts_app_key` longtext,
  `oss_access_key_id` longtext,
  `oss_access_key_secret` longtext,
  `oss_end_point` longtext,
  `oss_bucket_name` longtext,
  `oss_public_path` longtext,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of setting
-- ----------------------------
BEGIN;
INSERT INTO `setting` VALUES (1, '星际后台管理系统', '星际后台管理系统', '星际后台管理系统', 'https://jilu-ai.oss-cn-hangzhou.aliyuncs.com/image/20240706/3724781798752871.jpeg', '宁波科技有限公司', '1.0.3', 'https://mp-0964e3c4-75af-434f-9c7d-aa63e6f642c0.cdn.bspapp.com/cloudstorage/Star.apk', 'LTAI5tEZFBPZ3FiXyTr49bqJ', '123', 'pjUt7FdcW8rBZOGO', 'LTAI5tEZFBPZ3FiXyTr49bqJ', 'vHEaO5CP3vLeNNmyjtpxNMzyO3yL9x', 'oss-cn-hangzhou.aliyuncs.com', 'jilu-ai', 'https://jilu-ai.oss-cn-hangzhou.aliyuncs.com/');
COMMIT;

-- ----------------------------
-- Table structure for task
-- ----------------------------
DROP TABLE IF EXISTS `task`;
CREATE TABLE `task` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `done_count` int DEFAULT NULL,
  `done_days_total` int DEFAULT NULL,
  `last_done_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of task
-- ----------------------------
BEGIN;
INSERT INTO `task` VALUES (25, 5, NULL, '2024-07-09 00:36:26');
INSERT INTO `task` VALUES (26, 5, NULL, '2024-07-08 02:27:08');
INSERT INTO `task` VALUES (27, 0, NULL, NULL);
INSERT INTO `task` VALUES (28, 0, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` longtext,
  `display_name` longtext,
  `avatar` longtext,
  `phone` longtext,
  `country_code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `password` longtext,
  `role` longtext,
  `status` longtext,
  `language` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `expired` tinyint(1) DEFAULT NULL,
  `expire_at` datetime DEFAULT NULL,
  `session_id` longtext,
  `recommend_user_id` bigint DEFAULT NULL,
  `invite_code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `team_path` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `verify_status` bigint DEFAULT NULL,
  `real_name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `id_card` longtext,
  `star_point` bigint DEFAULT NULL,
  `created_at` datetime(3) DEFAULT NULL,
  `updated_at` datetime(3) DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `recommend_user_phone` longtext,
  `cell_star_point` bigint DEFAULT NULL,
  `cell_raw_star_point` bigint DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'admin', '管理员', 'https://jilu-ai.oss-cn-hangzhou.aliyuncs.com/image/20230908/2996704089498406.png', 'QhgSPwXFxDEyuAv_D120FA==', '86', '$2a$10$OM8ZwVfiUAsTUaLCz1GQJ.z8egdrnzX1sjjwaY6QX2w8sFiGIZ0lS', 'ADMIN', 'NORMAL', 'CN', NULL, NULL, NULL, NULL, 'kA9k2k7t', '1', 2, 'B-BxSK1EOf5P9fv5jFnIZA==', '4wqQuiAKu8f_4daieD7AuCaG9Kd-OI_SgoVS4Ms-yEc=', 0, '2024-06-21 11:45:08.000', '2024-07-07 20:49:00.880', NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (25, '4007796836929469', '86187****7803', 'https://jilu-ai.oss-cn-hangzhou.aliyuncs.com/image/20230908/2996704089498406.png', 'IbX37ftuoCFCkR9V8ChCVw==', '86', '$2a$10$OM8ZwVfiUAsTUaLCz1GQJ.z8egdrnzX1sjjwaY6QX2w8sFiGIZ0lS', 'CLIENT', 'NORMAL', 'CN', NULL, '2024-07-07 16:24:32', '', 1, '6n8nfC7C', '1,25', 0, 'B-BxSK1EOf5P9fv5jFnIZA==', '4wqQuiAKu8f_4daieD7AuCaG9Kd-OI_SgoVS4Ms-yEc=', 4, '2024-07-06 16:35:33.562', '2024-07-09 00:29:43.794', NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (26, '2548542960810276', '86131****0159', 'https://jilu-ai.oss-cn-hangzhou.aliyuncs.com/image/20230908/2996704089498406.png', 'CwFT4nr8VTAIKaRtKMk-TQ==', '86', '$2a$10$OM8ZwVfiUAsTUaLCz1GQJ.z8egdrnzX1sjjwaY6QX2w8sFiGIZ0lS', 'CLIENT', 'NORMAL', 'CN', NULL, NULL, '', 1, '8ucZrDgU', '1,26', 3, 'HZNjxeB1-90cYjVVO65jdg==', NULL, 0, '2024-07-07 12:10:08.734', '2024-07-09 03:13:15.958', NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (27, '0055309654833164', '86157****8554', 'https://jilu-ai.oss-cn-hangzhou.aliyuncs.com/image/20230908/2996704089498406.png', 'YNpH7tx7aDNsvE8ch3UwtQ==', '86', '$2a$10$dKFHYbSqXiWW1Np.cyVnTekSdBbLhJuKFI78j7bQdebJM9OoB4YTq', 'CLIENT', 'NORMAL', 'CN', NULL, NULL, '', 26, '2etLMN7l', '1,26,27', 2, 'o3NKB0UTkUdmnRVCIhVMRg==', 'o3NKB0UTkUdmnRVCIhVMRg==', 0, '2024-07-08 19:13:08.830', '2024-07-08 19:16:57.028', NULL, NULL, 0, 0);
INSERT INTO `user` VALUES (28, '7243024201214285', '86156****6821', 'https://jilu-ai.oss-cn-hangzhou.aliyuncs.com/image/20230908/2996704089498406.png', 'LARW3dp_aCBwvdUtNPAeyQ==', '86', '$2a$10$B/X6USwMUd.2TOSolts/TejLtigf7GGdy6gF9K63SmlF5/QM/smq6', 'CLIENT', 'NORMAL', 'CN', NULL, NULL, '', 26, 'Xu8t0Kd5', '1,26,28', 0, 'o3NKB0UTkUdmnRVCIhVMRg==', 'o3NKB0UTkUdmnRVCIhVMRg==', 0, '2024-07-08 21:38:47.471', '2024-07-08 21:38:47.471', NULL, NULL, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for wallet
-- ----------------------------
DROP TABLE IF EXISTS `wallet`;
CREATE TABLE `wallet` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `type` longtext,
  `binance_address` longtext,
  `binance_key` longtext,
  `binance_sync_block_number` bigint DEFAULT NULL,
  `binance_sync_time` datetime(3) DEFAULT NULL,
  `tron_address` longtext,
  `tron_key` longtext,
  PRIMARY KEY (`id`) USING BTREE,
  CONSTRAINT `fk_user_wallet` FOREIGN KEY (`id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of wallet
-- ----------------------------
BEGIN;
INSERT INTO `wallet` VALUES (25, 'binance', '0x8E3cB68d02E5D6BEbaE3d9b18865630EeD268553', '0xc8ee3f785e290ced41d4cd5fae240381d9ed38d10e3d99798cb5c51360830c0f', 40295135, '2024-07-08 21:56:04.228', 'address', 'privateKeyHex');
INSERT INTO `wallet` VALUES (26, 'binance', '0x5D688C6C45a8381023B7c861B9F85B59a2a1ec39', '0x7abe0d6d8ea149df466b129783bc3ae51517850cd410fde22cc6cecc37e53098', NULL, NULL, '', '');
INSERT INTO `wallet` VALUES (27, 'binance', '0x6843F78dA7c3BB89eA6562BFC4fEE22A9D6aE969', '0xad44793b46a09e99bfef96d1ed9a1bf76c9d4bde1a487e39a34efa44c3a2e680', NULL, NULL, '', '');
INSERT INTO `wallet` VALUES (28, 'binance', '0x346Ea2a36781730DC6B98f043B61C4Fd7203B025', '0x12d5ffe57d1b2ce086b1e289ecc8fac0a50ca2d697386c0f456ee35f641baf9c', NULL, NULL, '', '');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
